package pers.wwz.study.shardingjdbc.orm;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;


@Mapper
@Repository
public interface OrderAndOrderDetailMapper {

    @Select("SELECT t_order.order_id AS orderId,t_order_detail.goods_name AS goodsName FROM t_order ,t_order_detail WHERE t_order.order_id = t_order_detail.order_id")
    List<OrderAndOrderDetail> orderAndOrderDetailSelect();
 
}